PS: For a character vector to work, one needs to provide the .con argument glue_sql(), I think, so e.g.
glue_sql("{c('setosa', 'virginica')*}", .con = con)
if you use iris instead of mtcars.
4 Likes